﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="NorthwindDataSet" targetNamespace="http://tempuri.org/NorthwindDataSet.xsd" xmlns:mstns="http://tempuri.org/NorthwindDataSet.xsd" xmlns="http://tempuri.org/NorthwindDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="NorthwindConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="NorthwindConnectionString (Settings)" PropertyReference="ApplicationSettings.Docentric.Examples.Data.Properties.Settings.GlobalReference.Default.NorthwindConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmployeesTableAdapter" GeneratorDataComponentClassName="EmployeesTableAdapter" Name="Employees" UserDataComponentName="EmployeesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="NorthwindConnectionString (Settings)" DbObjectName="Employees" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Employees` WHERE ((`ID` = ?) AND ((? = 1 AND `Company` IS NULL) OR (`Company` = ?)) AND ((? = 1 AND `Last Name` IS NULL) OR (`Last Name` = ?)) AND ((? = 1 AND `First Name` IS NULL) OR (`First Name` = ?)) AND ((? = 1 AND `E-mail Address` IS NULL) OR (`E-mail Address` = ?)) AND ((? = 1 AND `Job Title` IS NULL) OR (`Job Title` = ?)) AND ((? = 1 AND `Business Phone` IS NULL) OR (`Business Phone` = ?)) AND ((? = 1 AND `Home Phone` IS NULL) OR (`Home Phone` = ?)) AND ((? = 1 AND `Mobile Phone` IS NULL) OR (`Mobile Phone` = ?)) AND ((? = 1 AND `Fax Number` IS NULL) OR (`Fax Number` = ?)) AND ((? = 1 AND `City` IS NULL) OR (`City` = ?)) AND ((? = 1 AND `State/Province` IS NULL) OR (`State/Province` = ?)) AND ((? = 1 AND `ZIP/Postal Code` IS NULL) OR (`ZIP/Postal Code` = ?)) AND ((? = 1 AND `Country/Region` IS NULL) OR (`Country/Region` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Last_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Last Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Last_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Last Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_First_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="First Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_First_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="First Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_E-mail_Address" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="E-mail Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_E-mail_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="E-mail Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Job_Title" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Job_Title" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Business_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Business Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Business_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Business Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Home_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Home Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Home_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Home Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Mobile_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Mobile Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Mobile_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mobile Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fax_Number" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fax Number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Fax_Number" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fax Number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_City" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_State/Province" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="State/Province" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_State/Province" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="State/Province" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ZIP/Postal_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ZIP/Postal Code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ZIP/Postal_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ZIP/Postal Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Country/Region" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Country/Region" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Country/Region" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country/Region" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Employees` (`Company`, `Last Name`, `First Name`, `E-mail Address`, `Job Title`, `Business Phone`, `Home Phone`, `Mobile Phone`, `Fax Number`, `Address`, `City`, `State/Province`, `ZIP/Postal Code`, `Country/Region`, `Web Page`, `Notes`, `Attachments`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Last_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Last Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="First_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="First Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="E-mail_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="E-mail Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Job_Title" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Business_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Business Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Home_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Home Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Mobile_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mobile Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Fax_Number" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fax Number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Address" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="State/Province" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="State/Province" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ZIP/Postal_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ZIP/Postal Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Country/Region" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country/Region" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Web_Page" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Web Page" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Notes" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Attachments" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Attachments" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Company, [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], Address, City, [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], Notes, Attachments FROM Employees</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Employees` SET `Company` = ?, `Last Name` = ?, `First Name` = ?, `E-mail Address` = ?, `Job Title` = ?, `Business Phone` = ?, `Home Phone` = ?, `Mobile Phone` = ?, `Fax Number` = ?, `Address` = ?, `City` = ?, `State/Province` = ?, `ZIP/Postal Code` = ?, `Country/Region` = ?, `Web Page` = ?, `Notes` = ?, `Attachments` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `Company` IS NULL) OR (`Company` = ?)) AND ((? = 1 AND `Last Name` IS NULL) OR (`Last Name` = ?)) AND ((? = 1 AND `First Name` IS NULL) OR (`First Name` = ?)) AND ((? = 1 AND `E-mail Address` IS NULL) OR (`E-mail Address` = ?)) AND ((? = 1 AND `Job Title` IS NULL) OR (`Job Title` = ?)) AND ((? = 1 AND `Business Phone` IS NULL) OR (`Business Phone` = ?)) AND ((? = 1 AND `Home Phone` IS NULL) OR (`Home Phone` = ?)) AND ((? = 1 AND `Mobile Phone` IS NULL) OR (`Mobile Phone` = ?)) AND ((? = 1 AND `Fax Number` IS NULL) OR (`Fax Number` = ?)) AND ((? = 1 AND `City` IS NULL) OR (`City` = ?)) AND ((? = 1 AND `State/Province` IS NULL) OR (`State/Province` = ?)) AND ((? = 1 AND `ZIP/Postal Code` IS NULL) OR (`ZIP/Postal Code` = ?)) AND ((? = 1 AND `Country/Region` IS NULL) OR (`Country/Region` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Last_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Last Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="First_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="First Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="E-mail_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="E-mail Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Job_Title" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Business_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Business Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Home_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Home Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Mobile_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mobile Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Fax_Number" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fax Number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Address" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="State/Province" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="State/Province" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ZIP/Postal_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ZIP/Postal Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Country/Region" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country/Region" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Web_Page" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Web Page" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Notes" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Attachments" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Attachments" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Last_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Last Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Last_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Last Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_First_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="First Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_First_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="First Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_E-mail_Address" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="E-mail Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_E-mail_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="E-mail Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Job_Title" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Job_Title" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Business_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Business Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Business_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Business Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Home_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Home Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Home_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Home Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Mobile_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Mobile Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Mobile_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mobile Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fax_Number" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fax Number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Fax_Number" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fax Number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_City" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_State/Province" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="State/Province" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_State/Province" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="State/Province" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ZIP/Postal_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ZIP/Postal Code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ZIP/Postal_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ZIP/Postal Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Country/Region" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Country/Region" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Country/Region" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country/Region" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Company" DataSetColumn="Company" />
              <Mapping SourceColumn="Last Name" DataSetColumn="Last Name" />
              <Mapping SourceColumn="First Name" DataSetColumn="First Name" />
              <Mapping SourceColumn="E-mail Address" DataSetColumn="E-mail Address" />
              <Mapping SourceColumn="Job Title" DataSetColumn="Job Title" />
              <Mapping SourceColumn="Business Phone" DataSetColumn="Business Phone" />
              <Mapping SourceColumn="Home Phone" DataSetColumn="Home Phone" />
              <Mapping SourceColumn="Mobile Phone" DataSetColumn="Mobile Phone" />
              <Mapping SourceColumn="Fax Number" DataSetColumn="Fax Number" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="State/Province" DataSetColumn="State/Province" />
              <Mapping SourceColumn="ZIP/Postal Code" DataSetColumn="ZIP/Postal Code" />
              <Mapping SourceColumn="Country/Region" DataSetColumn="Country/Region" />
              <Mapping SourceColumn="Web Page" DataSetColumn="Web Page" />
              <Mapping SourceColumn="Notes" DataSetColumn="Notes" />
              <Mapping SourceColumn="Attachments" DataSetColumn="Attachments" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductsTableAdapter" GeneratorDataComponentClassName="ProductsTableAdapter" Name="Products" UserDataComponentName="ProductsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="NorthwindConnectionString (Settings)" DbObjectName="Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Products` WHERE ((`ID` = ?) AND ((? = 1 AND `Product Code` IS NULL) OR (`Product Code` = ?)) AND ((? = 1 AND `Product Name` IS NULL) OR (`Product Name` = ?)) AND ((? = 1 AND `Standard Cost` IS NULL) OR (`Standard Cost` = ?)) AND ((? = 1 AND `List Price` IS NULL) OR (`List Price` = ?)) AND ((? = 1 AND `Reorder Level` IS NULL) OR (`Reorder Level` = ?)) AND ((? = 1 AND `Target Level` IS NULL) OR (`Target Level` = ?)) AND ((? = 1 AND `Quantity Per Unit` IS NULL) OR (`Quantity Per Unit` = ?)) AND ((? = 1 AND `Discontinued` IS NULL) OR (`Discontinued` = ?)) AND ((? = 1 AND `Minimum Reorder Quantity` IS NULL) OR (`Minimum Reorder Quantity` = ?)) AND ((? = 1 AND `Category` IS NULL) OR (`Category` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Product_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Product Code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Product_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Product Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Product_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Product Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Product_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Product Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Standard_Cost" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Standard Cost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Standard_Cost" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Standard Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_List_Price" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="List Price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_List_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="List Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Reorder_Level" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Reorder Level" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Reorder_Level" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Reorder Level" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Target_Level" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Target Level" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Target_Level" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Target Level" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Quantity_Per_Unit" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Quantity Per Unit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Quantity_Per_Unit" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Quantity Per Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Discontinued" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Discontinued" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_Discontinued" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Discontinued" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Minimum_Reorder_Quantity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Minimum Reorder Quantity" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Minimum_Reorder_Quantity" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Minimum Reorder Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Category" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Category" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Products` (`Supplier IDs`, `Product Code`, `Product Name`, `Description`, `Standard Cost`, `List Price`, `Reorder Level`, `Target Level`, `Quantity Per Unit`, `Discontinued`, `Minimum Reorder Quantity`, `Category`, `Attachments`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Supplier_IDs" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Supplier IDs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Product_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Product Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Product_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Product Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Standard_Cost" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Standard Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="List_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="List Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Reorder_Level" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Reorder Level" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Target_Level" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Target Level" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Quantity_Per_Unit" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Quantity Per Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Discontinued" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Discontinued" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Minimum_Reorder_Quantity" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Minimum Reorder Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Category" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Attachments" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Attachments" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Supplier IDs], ID, [Product Code], [Product Name], Description, [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], Discontinued, [Minimum Reorder Quantity], Category, Attachments FROM Products</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Products` SET `Supplier IDs` = ?, `Product Code` = ?, `Product Name` = ?, `Description` = ?, `Standard Cost` = ?, `List Price` = ?, `Reorder Level` = ?, `Target Level` = ?, `Quantity Per Unit` = ?, `Discontinued` = ?, `Minimum Reorder Quantity` = ?, `Category` = ?, `Attachments` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `Product Code` IS NULL) OR (`Product Code` = ?)) AND ((? = 1 AND `Product Name` IS NULL) OR (`Product Name` = ?)) AND ((? = 1 AND `Standard Cost` IS NULL) OR (`Standard Cost` = ?)) AND ((? = 1 AND `List Price` IS NULL) OR (`List Price` = ?)) AND ((? = 1 AND `Reorder Level` IS NULL) OR (`Reorder Level` = ?)) AND ((? = 1 AND `Target Level` IS NULL) OR (`Target Level` = ?)) AND ((? = 1 AND `Quantity Per Unit` IS NULL) OR (`Quantity Per Unit` = ?)) AND ((? = 1 AND `Discontinued` IS NULL) OR (`Discontinued` = ?)) AND ((? = 1 AND `Minimum Reorder Quantity` IS NULL) OR (`Minimum Reorder Quantity` = ?)) AND ((? = 1 AND `Category` IS NULL) OR (`Category` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Supplier_IDs" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Supplier IDs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Product_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Product Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Product_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Product Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Standard_Cost" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Standard Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="List_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="List Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Reorder_Level" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Reorder Level" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Target_Level" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Target Level" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Quantity_Per_Unit" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Quantity Per Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Discontinued" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Discontinued" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Minimum_Reorder_Quantity" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Minimum Reorder Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Category" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Attachments" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Attachments" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Product_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Product Code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Product_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Product Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Product_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Product Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Product_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Product Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Standard_Cost" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Standard Cost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Standard_Cost" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Standard Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_List_Price" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="List Price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_List_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="List Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Reorder_Level" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Reorder Level" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Reorder_Level" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Reorder Level" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Target_Level" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Target Level" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Target_Level" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Target Level" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Quantity_Per_Unit" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Quantity Per Unit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Quantity_Per_Unit" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Quantity Per Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Discontinued" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Discontinued" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_Discontinued" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Discontinued" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Minimum_Reorder_Quantity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Minimum Reorder Quantity" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Minimum_Reorder_Quantity" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Minimum Reorder Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Category" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Category" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Supplier IDs" DataSetColumn="Supplier IDs" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Product Code" DataSetColumn="Product Code" />
              <Mapping SourceColumn="Product Name" DataSetColumn="Product Name" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Standard Cost" DataSetColumn="Standard Cost" />
              <Mapping SourceColumn="List Price" DataSetColumn="List Price" />
              <Mapping SourceColumn="Reorder Level" DataSetColumn="Reorder Level" />
              <Mapping SourceColumn="Target Level" DataSetColumn="Target Level" />
              <Mapping SourceColumn="Quantity Per Unit" DataSetColumn="Quantity Per Unit" />
              <Mapping SourceColumn="Discontinued" DataSetColumn="Discontinued" />
              <Mapping SourceColumn="Minimum Reorder Quantity" DataSetColumn="Minimum Reorder Quantity" />
              <Mapping SourceColumn="Category" DataSetColumn="Category" />
              <Mapping SourceColumn="Attachments" DataSetColumn="Attachments" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Purchase Order DetailsTableAdapter" GeneratorDataComponentClassName="Purchase_Order_DetailsTableAdapter" Name="Purchase Order Details" UserDataComponentName="Purchase Order DetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="NorthwindConnectionString (Settings)" DbObjectName="Purchase Order Details" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Purchase Order Details` WHERE ((`ID` = ?) AND ((? = 1 AND `Purchase Order ID` IS NULL) OR (`Purchase Order ID` = ?)) AND ((? = 1 AND `Product ID` IS NULL) OR (`Product ID` = ?)) AND ((? = 1 AND `Quantity` IS NULL) OR (`Quantity` = ?)) AND ((? = 1 AND `Unit Cost` IS NULL) OR (`Unit Cost` = ?)) AND ((? = 1 AND `Date Received` IS NULL) OR (`Date Received` = ?)) AND ((? = 1 AND `Posted To Inventory` IS NULL) OR (`Posted To Inventory` = ?)) AND ((? = 1 AND `Inventory ID` IS NULL) OR (`Inventory ID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Purchase_Order_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Purchase Order ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Purchase_Order_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Purchase Order ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Product_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Product ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Product_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Product ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Quantity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_Quantity" Precision="18" ProviderType="Numeric" Scale="4" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Unit_Cost" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Unit Cost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Unit_Cost" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Unit Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Date_Received" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Date Received" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Date_Received" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date Received" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Posted_To_Inventory" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Posted To Inventory" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_Posted_To_Inventory" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Posted To Inventory" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Inventory_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Inventory ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Inventory_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Inventory ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Purchase Order Details` (`Purchase Order ID`, `Product ID`, `Quantity`, `Unit Cost`, `Date Received`, `Posted To Inventory`, `Inventory ID`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Purchase_Order_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Purchase Order ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Product_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Product ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Quantity" Precision="18" ProviderType="Numeric" Scale="4" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Unit_Cost" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Unit Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Date_Received" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date Received" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Posted_To_Inventory" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Posted To Inventory" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Inventory_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Inventory ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, [Purchase Order ID], [Product ID], Quantity, [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID] FROM [Purchase Order Details]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Purchase Order Details` SET `Purchase Order ID` = ?, `Product ID` = ?, `Quantity` = ?, `Unit Cost` = ?, `Date Received` = ?, `Posted To Inventory` = ?, `Inventory ID` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `Purchase Order ID` IS NULL) OR (`Purchase Order ID` = ?)) AND ((? = 1 AND `Product ID` IS NULL) OR (`Product ID` = ?)) AND ((? = 1 AND `Quantity` IS NULL) OR (`Quantity` = ?)) AND ((? = 1 AND `Unit Cost` IS NULL) OR (`Unit Cost` = ?)) AND ((? = 1 AND `Date Received` IS NULL) OR (`Date Received` = ?)) AND ((? = 1 AND `Posted To Inventory` IS NULL) OR (`Posted To Inventory` = ?)) AND ((? = 1 AND `Inventory ID` IS NULL) OR (`Inventory ID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Purchase_Order_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Purchase Order ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Product_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Product ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Quantity" Precision="18" ProviderType="Numeric" Scale="4" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Unit_Cost" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Unit Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Date_Received" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date Received" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Posted_To_Inventory" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Posted To Inventory" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Inventory_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Inventory ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Purchase_Order_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Purchase Order ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Purchase_Order_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Purchase Order ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Product_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Product ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Product_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Product ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Quantity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_Quantity" Precision="18" ProviderType="Numeric" Scale="4" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Unit_Cost" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Unit Cost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Unit_Cost" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Unit Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Date_Received" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Date Received" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Date_Received" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date Received" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Posted_To_Inventory" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Posted To Inventory" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_Posted_To_Inventory" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Posted To Inventory" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Inventory_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Inventory ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Inventory_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Inventory ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Purchase Order ID" DataSetColumn="Purchase Order ID" />
              <Mapping SourceColumn="Product ID" DataSetColumn="Product ID" />
              <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
              <Mapping SourceColumn="Unit Cost" DataSetColumn="Unit Cost" />
              <Mapping SourceColumn="Date Received" DataSetColumn="Date Received" />
              <Mapping SourceColumn="Posted To Inventory" DataSetColumn="Posted To Inventory" />
              <Mapping SourceColumn="Inventory ID" DataSetColumn="Inventory ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Purchase OrdersTableAdapter" GeneratorDataComponentClassName="Purchase_OrdersTableAdapter" Name="Purchase Orders" UserDataComponentName="Purchase OrdersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="NorthwindConnectionString (Settings)" DbObjectName="Purchase Orders" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Purchase Orders` WHERE ((`Purchase Order ID` = ?) AND ((? = 1 AND `Supplier ID` IS NULL) OR (`Supplier ID` = ?)) AND ((? = 1 AND `Created By` IS NULL) OR (`Created By` = ?)) AND ((? = 1 AND `Submitted Date` IS NULL) OR (`Submitted Date` = ?)) AND ((? = 1 AND `Creation Date` IS NULL) OR (`Creation Date` = ?)) AND ((? = 1 AND `Status ID` IS NULL) OR (`Status ID` = ?)) AND ((? = 1 AND `Expected Date` IS NULL) OR (`Expected Date` = ?)) AND ((? = 1 AND `Shipping Fee` IS NULL) OR (`Shipping Fee` = ?)) AND ((? = 1 AND `Taxes` IS NULL) OR (`Taxes` = ?)) AND ((? = 1 AND `Payment Date` IS NULL) OR (`Payment Date` = ?)) AND ((? = 1 AND `Payment Amount` IS NULL) OR (`Payment Amount` = ?)) AND ((? = 1 AND `Payment Method` IS NULL) OR (`Payment Method` = ?)) AND ((? = 1 AND `Approved By` IS NULL) OR (`Approved By` = ?)) AND ((? = 1 AND `Approved Date` IS NULL) OR (`Approved Date` = ?)) AND ((? = 1 AND `Submitted By` IS NULL) OR (`Submitted By` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Purchase_Order_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Purchase Order ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Supplier_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Supplier ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Supplier_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Supplier ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Created_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Created By" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Created_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Created By" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Submitted_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Submitted Date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Submitted_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Submitted Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Creation_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Creation Date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Creation_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Creation Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Status_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Status ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Status_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Status ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Expected_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Expected Date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Expected_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Expected Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Shipping_Fee" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Shipping Fee" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Shipping_Fee" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Shipping Fee" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Taxes" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Taxes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Taxes" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Taxes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Payment_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Payment Date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Payment_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Payment Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Payment_Amount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Payment Amount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Payment_Amount" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Payment Amount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Payment_Method" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Payment Method" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Payment_Method" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Payment Method" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Approved_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Approved By" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Approved_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Approved By" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Approved_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Approved Date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Approved_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Approved Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Submitted_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Submitted By" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Submitted_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Submitted By" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Purchase Orders` (`Supplier ID`, `Created By`, `Submitted Date`, `Creation Date`, `Status ID`, `Expected Date`, `Shipping Fee`, `Taxes`, `Payment Date`, `Payment Amount`, `Payment Method`, `Notes`, `Approved By`, `Approved Date`, `Submitted By`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Supplier_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Supplier ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Created_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Created By" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Submitted_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Submitted Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Creation_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Creation Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Status_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Status ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Expected_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Expected Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Shipping_Fee" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Shipping Fee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Taxes" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Taxes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Payment_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Payment Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Payment_Amount" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Payment Amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Payment_Method" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Payment Method" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Notes" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Approved_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Approved By" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Approved_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Approved Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Submitted_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Submitted By" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], Taxes, [Payment Date], [Payment Amount], [Payment Method], Notes, [Approved By], [Approved Date], [Submitted By] FROM [Purchase Orders]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Purchase Orders` SET `Supplier ID` = ?, `Created By` = ?, `Submitted Date` = ?, `Creation Date` = ?, `Status ID` = ?, `Expected Date` = ?, `Shipping Fee` = ?, `Taxes` = ?, `Payment Date` = ?, `Payment Amount` = ?, `Payment Method` = ?, `Notes` = ?, `Approved By` = ?, `Approved Date` = ?, `Submitted By` = ? WHERE ((`Purchase Order ID` = ?) AND ((? = 1 AND `Supplier ID` IS NULL) OR (`Supplier ID` = ?)) AND ((? = 1 AND `Created By` IS NULL) OR (`Created By` = ?)) AND ((? = 1 AND `Submitted Date` IS NULL) OR (`Submitted Date` = ?)) AND ((? = 1 AND `Creation Date` IS NULL) OR (`Creation Date` = ?)) AND ((? = 1 AND `Status ID` IS NULL) OR (`Status ID` = ?)) AND ((? = 1 AND `Expected Date` IS NULL) OR (`Expected Date` = ?)) AND ((? = 1 AND `Shipping Fee` IS NULL) OR (`Shipping Fee` = ?)) AND ((? = 1 AND `Taxes` IS NULL) OR (`Taxes` = ?)) AND ((? = 1 AND `Payment Date` IS NULL) OR (`Payment Date` = ?)) AND ((? = 1 AND `Payment Amount` IS NULL) OR (`Payment Amount` = ?)) AND ((? = 1 AND `Payment Method` IS NULL) OR (`Payment Method` = ?)) AND ((? = 1 AND `Approved By` IS NULL) OR (`Approved By` = ?)) AND ((? = 1 AND `Approved Date` IS NULL) OR (`Approved Date` = ?)) AND ((? = 1 AND `Submitted By` IS NULL) OR (`Submitted By` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Supplier_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Supplier ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Created_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Created By" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Submitted_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Submitted Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Creation_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Creation Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Status_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Status ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Expected_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Expected Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Shipping_Fee" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Shipping Fee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Taxes" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Taxes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Payment_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Payment Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Payment_Amount" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Payment Amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Payment_Method" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Payment Method" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Notes" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Approved_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Approved By" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Approved_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Approved Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Submitted_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Submitted By" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Purchase_Order_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Purchase Order ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Supplier_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Supplier ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Supplier_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Supplier ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Created_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Created By" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Created_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Created By" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Submitted_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Submitted Date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Submitted_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Submitted Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Creation_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Creation Date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Creation_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Creation Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Status_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Status ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Status_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Status ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Expected_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Expected Date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Expected_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Expected Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Shipping_Fee" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Shipping Fee" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Shipping_Fee" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Shipping Fee" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Taxes" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Taxes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Taxes" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Taxes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Payment_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Payment Date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Payment_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Payment Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Payment_Amount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Payment Amount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Payment_Amount" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Payment Amount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Payment_Method" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Payment Method" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Payment_Method" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Payment Method" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Approved_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Approved By" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Approved_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Approved By" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Approved_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Approved Date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Approved_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Approved Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Submitted_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Submitted By" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Submitted_By" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Submitted By" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Purchase Order ID" DataSetColumn="Purchase Order ID" />
              <Mapping SourceColumn="Supplier ID" DataSetColumn="Supplier ID" />
              <Mapping SourceColumn="Created By" DataSetColumn="Created By" />
              <Mapping SourceColumn="Submitted Date" DataSetColumn="Submitted Date" />
              <Mapping SourceColumn="Creation Date" DataSetColumn="Creation Date" />
              <Mapping SourceColumn="Status ID" DataSetColumn="Status ID" />
              <Mapping SourceColumn="Expected Date" DataSetColumn="Expected Date" />
              <Mapping SourceColumn="Shipping Fee" DataSetColumn="Shipping Fee" />
              <Mapping SourceColumn="Taxes" DataSetColumn="Taxes" />
              <Mapping SourceColumn="Payment Date" DataSetColumn="Payment Date" />
              <Mapping SourceColumn="Payment Amount" DataSetColumn="Payment Amount" />
              <Mapping SourceColumn="Payment Method" DataSetColumn="Payment Method" />
              <Mapping SourceColumn="Notes" DataSetColumn="Notes" />
              <Mapping SourceColumn="Approved By" DataSetColumn="Approved By" />
              <Mapping SourceColumn="Approved Date" DataSetColumn="Approved Date" />
              <Mapping SourceColumn="Submitted By" DataSetColumn="Submitted By" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SuppliersTableAdapter" GeneratorDataComponentClassName="SuppliersTableAdapter" Name="Suppliers" UserDataComponentName="SuppliersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="NorthwindConnectionString (Settings)" DbObjectName="Suppliers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Suppliers` WHERE ((`ID` = ?) AND ((? = 1 AND `Company` IS NULL) OR (`Company` = ?)) AND ((? = 1 AND `Last Name` IS NULL) OR (`Last Name` = ?)) AND ((? = 1 AND `First Name` IS NULL) OR (`First Name` = ?)) AND ((? = 1 AND `E-mail Address` IS NULL) OR (`E-mail Address` = ?)) AND ((? = 1 AND `Job Title` IS NULL) OR (`Job Title` = ?)) AND ((? = 1 AND `Business Phone` IS NULL) OR (`Business Phone` = ?)) AND ((? = 1 AND `Home Phone` IS NULL) OR (`Home Phone` = ?)) AND ((? = 1 AND `Mobile Phone` IS NULL) OR (`Mobile Phone` = ?)) AND ((? = 1 AND `Fax Number` IS NULL) OR (`Fax Number` = ?)) AND ((? = 1 AND `City` IS NULL) OR (`City` = ?)) AND ((? = 1 AND `State/Province` IS NULL) OR (`State/Province` = ?)) AND ((? = 1 AND `ZIP/Postal Code` IS NULL) OR (`ZIP/Postal Code` = ?)) AND ((? = 1 AND `Country/Region` IS NULL) OR (`Country/Region` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Last_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Last Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Last_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Last Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_First_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="First Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_First_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="First Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_E-mail_Address" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="E-mail Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_E-mail_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="E-mail Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Job_Title" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Job_Title" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Business_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Business Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Business_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Business Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Home_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Home Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Home_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Home Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Mobile_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Mobile Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Mobile_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mobile Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fax_Number" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fax Number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Fax_Number" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fax Number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_City" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_State/Province" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="State/Province" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_State/Province" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="State/Province" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ZIP/Postal_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ZIP/Postal Code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ZIP/Postal_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ZIP/Postal Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Country/Region" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Country/Region" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Country/Region" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country/Region" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Suppliers` (`Company`, `Last Name`, `First Name`, `E-mail Address`, `Job Title`, `Business Phone`, `Home Phone`, `Mobile Phone`, `Fax Number`, `Address`, `City`, `State/Province`, `ZIP/Postal Code`, `Country/Region`, `Web Page`, `Notes`, `Attachments`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Last_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Last Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="First_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="First Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="E-mail_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="E-mail Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Job_Title" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Business_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Business Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Home_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Home Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Mobile_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mobile Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Fax_Number" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fax Number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Address" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="State/Province" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="State/Province" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ZIP/Postal_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ZIP/Postal Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Country/Region" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country/Region" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Web_Page" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Web Page" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Notes" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Attachments" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Attachments" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Company, [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], Address, City, [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], Notes, Attachments FROM Suppliers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Suppliers` SET `Company` = ?, `Last Name` = ?, `First Name` = ?, `E-mail Address` = ?, `Job Title` = ?, `Business Phone` = ?, `Home Phone` = ?, `Mobile Phone` = ?, `Fax Number` = ?, `Address` = ?, `City` = ?, `State/Province` = ?, `ZIP/Postal Code` = ?, `Country/Region` = ?, `Web Page` = ?, `Notes` = ?, `Attachments` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `Company` IS NULL) OR (`Company` = ?)) AND ((? = 1 AND `Last Name` IS NULL) OR (`Last Name` = ?)) AND ((? = 1 AND `First Name` IS NULL) OR (`First Name` = ?)) AND ((? = 1 AND `E-mail Address` IS NULL) OR (`E-mail Address` = ?)) AND ((? = 1 AND `Job Title` IS NULL) OR (`Job Title` = ?)) AND ((? = 1 AND `Business Phone` IS NULL) OR (`Business Phone` = ?)) AND ((? = 1 AND `Home Phone` IS NULL) OR (`Home Phone` = ?)) AND ((? = 1 AND `Mobile Phone` IS NULL) OR (`Mobile Phone` = ?)) AND ((? = 1 AND `Fax Number` IS NULL) OR (`Fax Number` = ?)) AND ((? = 1 AND `City` IS NULL) OR (`City` = ?)) AND ((? = 1 AND `State/Province` IS NULL) OR (`State/Province` = ?)) AND ((? = 1 AND `ZIP/Postal Code` IS NULL) OR (`ZIP/Postal Code` = ?)) AND ((? = 1 AND `Country/Region` IS NULL) OR (`Country/Region` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Last_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Last Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="First_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="First Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="E-mail_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="E-mail Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Job_Title" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Business_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Business Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Home_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Home Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Mobile_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mobile Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Fax_Number" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fax Number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Address" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="State/Province" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="State/Province" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ZIP/Postal_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ZIP/Postal Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Country/Region" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country/Region" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Web_Page" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Web Page" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Notes" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Attachments" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Attachments" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Last_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Last Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Last_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Last Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_First_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="First Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_First_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="First Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_E-mail_Address" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="E-mail Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_E-mail_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="E-mail Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Job_Title" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Job_Title" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Job Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Business_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Business Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Business_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Business Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Home_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Home Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Home_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Home Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Mobile_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Mobile Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Mobile_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Mobile Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fax_Number" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fax Number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Fax_Number" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fax Number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_City" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_State/Province" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="State/Province" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_State/Province" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="State/Province" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ZIP/Postal_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ZIP/Postal Code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ZIP/Postal_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ZIP/Postal Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Country/Region" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Country/Region" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Country/Region" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country/Region" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Company" DataSetColumn="Company" />
              <Mapping SourceColumn="Last Name" DataSetColumn="Last Name" />
              <Mapping SourceColumn="First Name" DataSetColumn="First Name" />
              <Mapping SourceColumn="E-mail Address" DataSetColumn="E-mail Address" />
              <Mapping SourceColumn="Job Title" DataSetColumn="Job Title" />
              <Mapping SourceColumn="Business Phone" DataSetColumn="Business Phone" />
              <Mapping SourceColumn="Home Phone" DataSetColumn="Home Phone" />
              <Mapping SourceColumn="Mobile Phone" DataSetColumn="Mobile Phone" />
              <Mapping SourceColumn="Fax Number" DataSetColumn="Fax Number" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="State/Province" DataSetColumn="State/Province" />
              <Mapping SourceColumn="ZIP/Postal Code" DataSetColumn="ZIP/Postal Code" />
              <Mapping SourceColumn="Country/Region" DataSetColumn="Country/Region" />
              <Mapping SourceColumn="Web Page" DataSetColumn="Web Page" />
              <Mapping SourceColumn="Notes" DataSetColumn="Notes" />
              <Mapping SourceColumn="Attachments" DataSetColumn="Attachments" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="NorthwindDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="NorthwindDataSet" msprop:Generator_UserDSName="NorthwindDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Employees" msprop:Generator_TableClassName="EmployeesDataTable" msprop:Generator_TableVarName="tableEmployees" msprop:Generator_TablePropName="Employees" msprop:Generator_RowDeletingName="EmployeesRowDeleting" msprop:Generator_UserTableName="Employees" msprop:Generator_RowChangingName="EmployeesRowChanging" msprop:Generator_RowEvHandlerName="EmployeesRowChangeEventHandler" msprop:Generator_RowDeletedName="EmployeesRowDeleted" msprop:Generator_RowEvArgName="EmployeesRowChangeEvent" msprop:Generator_RowChangedName="EmployeesRowChanged" msprop:Generator_RowClassName="EmployeesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Company" msprop:Generator_ColumnVarNameInTable="columnCompany" msprop:Generator_ColumnPropNameInRow="Company" msprop:Generator_ColumnPropNameInTable="CompanyColumn" msprop:Generator_UserColumnName="Company" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Last_x0020_Name" msprop:Generator_ColumnVarNameInTable="columnLast_Name" msprop:Generator_ColumnPropNameInRow="Last_Name" msprop:Generator_ColumnPropNameInTable="Last_NameColumn" msprop:Generator_UserColumnName="Last Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="First_x0020_Name" msprop:Generator_ColumnVarNameInTable="columnFirst_Name" msprop:Generator_ColumnPropNameInRow="First_Name" msprop:Generator_ColumnPropNameInTable="First_NameColumn" msprop:Generator_UserColumnName="First Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E-mail_x0020_Address" msprop:Generator_ColumnVarNameInTable="_columnE_mail_Address" msprop:Generator_ColumnPropNameInRow="_E_mail_Address" msprop:Generator_ColumnPropNameInTable="_E_mail_AddressColumn" msprop:Generator_UserColumnName="E-mail Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Job_x0020_Title" msprop:Generator_ColumnVarNameInTable="columnJob_Title" msprop:Generator_ColumnPropNameInRow="Job_Title" msprop:Generator_ColumnPropNameInTable="Job_TitleColumn" msprop:Generator_UserColumnName="Job Title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Business_x0020_Phone" msprop:Generator_ColumnVarNameInTable="columnBusiness_Phone" msprop:Generator_ColumnPropNameInRow="Business_Phone" msprop:Generator_ColumnPropNameInTable="Business_PhoneColumn" msprop:Generator_UserColumnName="Business Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Home_x0020_Phone" msprop:Generator_ColumnVarNameInTable="columnHome_Phone" msprop:Generator_ColumnPropNameInRow="Home_Phone" msprop:Generator_ColumnPropNameInTable="Home_PhoneColumn" msprop:Generator_UserColumnName="Home Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Mobile_x0020_Phone" msprop:Generator_ColumnVarNameInTable="columnMobile_Phone" msprop:Generator_ColumnPropNameInRow="Mobile_Phone" msprop:Generator_ColumnPropNameInTable="Mobile_PhoneColumn" msprop:Generator_UserColumnName="Mobile Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fax_x0020_Number" msprop:Generator_ColumnVarNameInTable="columnFax_Number" msprop:Generator_ColumnPropNameInRow="Fax_Number" msprop:Generator_ColumnPropNameInTable="Fax_NumberColumn" msprop:Generator_UserColumnName="Fax Number" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State_x002F_Province" msprop:Generator_ColumnVarNameInTable="_columnState_Province" msprop:Generator_ColumnPropNameInRow="_State_Province" msprop:Generator_ColumnPropNameInTable="_State_ProvinceColumn" msprop:Generator_UserColumnName="State/Province" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ZIP_x002F_Postal_x0020_Code" msprop:Generator_ColumnVarNameInTable="_columnZIP_Postal_Code" msprop:Generator_ColumnPropNameInRow="_ZIP_Postal_Code" msprop:Generator_ColumnPropNameInTable="_ZIP_Postal_CodeColumn" msprop:Generator_UserColumnName="ZIP/Postal Code" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country_x002F_Region" msprop:Generator_ColumnVarNameInTable="_columnCountry_Region" msprop:Generator_ColumnPropNameInRow="_Country_Region" msprop:Generator_ColumnPropNameInTable="_Country_RegionColumn" msprop:Generator_UserColumnName="Country/Region" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Web_x0020_Page" msprop:Generator_ColumnVarNameInTable="columnWeb_Page" msprop:Generator_ColumnPropNameInRow="Web_Page" msprop:Generator_ColumnPropNameInTable="Web_PageColumn" msprop:Generator_UserColumnName="Web Page" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnPropNameInTable="NotesColumn" msprop:Generator_UserColumnName="Notes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Attachments" msprop:Generator_ColumnVarNameInTable="columnAttachments" msprop:Generator_ColumnPropNameInRow="Attachments" msprop:Generator_ColumnPropNameInTable="AttachmentsColumn" msprop:Generator_UserColumnName="Attachments" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Products" msprop:Generator_TableClassName="ProductsDataTable" msprop:Generator_TableVarName="tableProducts" msprop:Generator_TablePropName="Products" msprop:Generator_RowDeletingName="ProductsRowDeleting" msprop:Generator_UserTableName="Products" msprop:Generator_RowChangingName="ProductsRowChanging" msprop:Generator_RowEvHandlerName="ProductsRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductsRowDeleted" msprop:Generator_RowEvArgName="ProductsRowChangeEvent" msprop:Generator_RowChangedName="ProductsRowChanged" msprop:Generator_RowClassName="ProductsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Supplier_x0020_IDs" msprop:Generator_ColumnVarNameInTable="columnSupplier_IDs" msprop:Generator_ColumnPropNameInRow="Supplier_IDs" msprop:Generator_ColumnPropNameInTable="Supplier_IDsColumn" msprop:Generator_UserColumnName="Supplier IDs" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Product_x0020_Code" msprop:Generator_ColumnVarNameInTable="columnProduct_Code" msprop:Generator_ColumnPropNameInRow="Product_Code" msprop:Generator_ColumnPropNameInTable="Product_CodeColumn" msprop:Generator_UserColumnName="Product Code" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Product_x0020_Name" msprop:Generator_ColumnVarNameInTable="columnProduct_Name" msprop:Generator_ColumnPropNameInRow="Product_Name" msprop:Generator_ColumnPropNameInTable="Product_NameColumn" msprop:Generator_UserColumnName="Product Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Standard_x0020_Cost" msprop:Generator_ColumnVarNameInTable="columnStandard_Cost" msprop:Generator_ColumnPropNameInRow="Standard_Cost" msprop:Generator_ColumnPropNameInTable="Standard_CostColumn" msprop:Generator_UserColumnName="Standard Cost" type="xs:decimal" minOccurs="0" />
              <xs:element name="List_x0020_Price" msprop:Generator_ColumnVarNameInTable="columnList_Price" msprop:Generator_ColumnPropNameInRow="List_Price" msprop:Generator_ColumnPropNameInTable="List_PriceColumn" msprop:Generator_UserColumnName="List Price" type="xs:decimal" minOccurs="0" />
              <xs:element name="Reorder_x0020_Level" msprop:Generator_ColumnVarNameInTable="columnReorder_Level" msprop:Generator_ColumnPropNameInRow="Reorder_Level" msprop:Generator_ColumnPropNameInTable="Reorder_LevelColumn" msprop:Generator_UserColumnName="Reorder Level" type="xs:short" minOccurs="0" />
              <xs:element name="Target_x0020_Level" msprop:Generator_ColumnVarNameInTable="columnTarget_Level" msprop:Generator_ColumnPropNameInRow="Target_Level" msprop:Generator_ColumnPropNameInTable="Target_LevelColumn" msprop:Generator_UserColumnName="Target Level" type="xs:int" minOccurs="0" />
              <xs:element name="Quantity_x0020_Per_x0020_Unit" msprop:Generator_ColumnVarNameInTable="columnQuantity_Per_Unit" msprop:Generator_ColumnPropNameInRow="Quantity_Per_Unit" msprop:Generator_ColumnPropNameInTable="Quantity_Per_UnitColumn" msprop:Generator_UserColumnName="Quantity Per Unit" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Discontinued" msprop:Generator_ColumnVarNameInTable="columnDiscontinued" msprop:Generator_ColumnPropNameInRow="Discontinued" msprop:Generator_ColumnPropNameInTable="DiscontinuedColumn" msprop:Generator_UserColumnName="Discontinued" type="xs:boolean" minOccurs="0" />
              <xs:element name="Minimum_x0020_Reorder_x0020_Quantity" msprop:Generator_ColumnVarNameInTable="columnMinimum_Reorder_Quantity" msprop:Generator_ColumnPropNameInRow="Minimum_Reorder_Quantity" msprop:Generator_ColumnPropNameInTable="Minimum_Reorder_QuantityColumn" msprop:Generator_UserColumnName="Minimum Reorder Quantity" type="xs:short" minOccurs="0" />
              <xs:element name="Category" msprop:Generator_ColumnVarNameInTable="columnCategory" msprop:Generator_ColumnPropNameInRow="Category" msprop:Generator_ColumnPropNameInTable="CategoryColumn" msprop:Generator_UserColumnName="Category" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Attachments" msprop:Generator_ColumnVarNameInTable="columnAttachments" msprop:Generator_ColumnPropNameInRow="Attachments" msprop:Generator_ColumnPropNameInTable="AttachmentsColumn" msprop:Generator_UserColumnName="Attachments" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Purchase_x0020_Order_x0020_Details" msprop:Generator_TableClassName="Purchase_Order_DetailsDataTable" msprop:Generator_TableVarName="tablePurchase_Order_Details" msprop:Generator_TablePropName="Purchase_Order_Details" msprop:Generator_RowDeletingName="Purchase_Order_DetailsRowDeleting" msprop:Generator_UserTableName="Purchase Order Details" msprop:Generator_RowChangingName="Purchase_Order_DetailsRowChanging" msprop:Generator_RowEvHandlerName="Purchase_Order_DetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="Purchase_Order_DetailsRowDeleted" msprop:Generator_RowEvArgName="Purchase_Order_DetailsRowChangeEvent" msprop:Generator_RowChangedName="Purchase_Order_DetailsRowChanged" msprop:Generator_RowClassName="Purchase_Order_DetailsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Purchase_x0020_Order_x0020_ID" msprop:Generator_ColumnVarNameInTable="columnPurchase_Order_ID" msprop:Generator_ColumnPropNameInRow="Purchase_Order_ID" msprop:Generator_ColumnPropNameInTable="Purchase_Order_IDColumn" msprop:Generator_UserColumnName="Purchase Order ID" type="xs:int" minOccurs="0" />
              <xs:element name="Product_x0020_ID" msprop:Generator_ColumnVarNameInTable="columnProduct_ID" msprop:Generator_ColumnPropNameInRow="Product_ID" msprop:Generator_ColumnPropNameInTable="Product_IDColumn" msprop:Generator_UserColumnName="Product ID" type="xs:int" minOccurs="0" />
              <xs:element name="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" type="xs:decimal" minOccurs="0" />
              <xs:element name="Unit_x0020_Cost" msprop:Generator_ColumnVarNameInTable="columnUnit_Cost" msprop:Generator_ColumnPropNameInRow="Unit_Cost" msprop:Generator_ColumnPropNameInTable="Unit_CostColumn" msprop:Generator_UserColumnName="Unit Cost" type="xs:decimal" minOccurs="0" />
              <xs:element name="Date_x0020_Received" msprop:Generator_ColumnVarNameInTable="columnDate_Received" msprop:Generator_ColumnPropNameInRow="Date_Received" msprop:Generator_ColumnPropNameInTable="Date_ReceivedColumn" msprop:Generator_UserColumnName="Date Received" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Posted_x0020_To_x0020_Inventory" msprop:Generator_ColumnVarNameInTable="columnPosted_To_Inventory" msprop:Generator_ColumnPropNameInRow="Posted_To_Inventory" msprop:Generator_ColumnPropNameInTable="Posted_To_InventoryColumn" msprop:Generator_UserColumnName="Posted To Inventory" type="xs:boolean" minOccurs="0" />
              <xs:element name="Inventory_x0020_ID" msprop:Generator_ColumnVarNameInTable="columnInventory_ID" msprop:Generator_ColumnPropNameInRow="Inventory_ID" msprop:Generator_ColumnPropNameInTable="Inventory_IDColumn" msprop:Generator_UserColumnName="Inventory ID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Purchase_x0020_Orders" msprop:Generator_TableClassName="Purchase_OrdersDataTable" msprop:Generator_TableVarName="tablePurchase_Orders" msprop:Generator_TablePropName="Purchase_Orders" msprop:Generator_RowDeletingName="Purchase_OrdersRowDeleting" msprop:Generator_UserTableName="Purchase Orders" msprop:Generator_RowChangingName="Purchase_OrdersRowChanging" msprop:Generator_RowEvHandlerName="Purchase_OrdersRowChangeEventHandler" msprop:Generator_RowDeletedName="Purchase_OrdersRowDeleted" msprop:Generator_RowEvArgName="Purchase_OrdersRowChangeEvent" msprop:Generator_RowChangedName="Purchase_OrdersRowChanged" msprop:Generator_RowClassName="Purchase_OrdersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Purchase_x0020_Order_x0020_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPurchase_Order_ID" msprop:Generator_ColumnPropNameInRow="Purchase_Order_ID" msprop:Generator_ColumnPropNameInTable="Purchase_Order_IDColumn" msprop:Generator_UserColumnName="Purchase Order ID" type="xs:int" />
              <xs:element name="Supplier_x0020_ID" msprop:Generator_ColumnVarNameInTable="columnSupplier_ID" msprop:Generator_ColumnPropNameInRow="Supplier_ID" msprop:Generator_ColumnPropNameInTable="Supplier_IDColumn" msprop:Generator_UserColumnName="Supplier ID" type="xs:int" minOccurs="0" />
              <xs:element name="Created_x0020_By" msprop:Generator_ColumnVarNameInTable="columnCreated_By" msprop:Generator_ColumnPropNameInRow="Created_By" msprop:Generator_ColumnPropNameInTable="Created_ByColumn" msprop:Generator_UserColumnName="Created By" type="xs:int" minOccurs="0" />
              <xs:element name="Submitted_x0020_Date" msprop:Generator_ColumnVarNameInTable="columnSubmitted_Date" msprop:Generator_ColumnPropNameInRow="Submitted_Date" msprop:Generator_ColumnPropNameInTable="Submitted_DateColumn" msprop:Generator_UserColumnName="Submitted Date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Creation_x0020_Date" msprop:Generator_ColumnVarNameInTable="columnCreation_Date" msprop:Generator_ColumnPropNameInRow="Creation_Date" msprop:Generator_ColumnPropNameInTable="Creation_DateColumn" msprop:Generator_UserColumnName="Creation Date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Status_x0020_ID" msprop:Generator_ColumnVarNameInTable="columnStatus_ID" msprop:Generator_ColumnPropNameInRow="Status_ID" msprop:Generator_ColumnPropNameInTable="Status_IDColumn" msprop:Generator_UserColumnName="Status ID" type="xs:int" minOccurs="0" />
              <xs:element name="Expected_x0020_Date" msprop:Generator_ColumnVarNameInTable="columnExpected_Date" msprop:Generator_ColumnPropNameInRow="Expected_Date" msprop:Generator_ColumnPropNameInTable="Expected_DateColumn" msprop:Generator_UserColumnName="Expected Date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Shipping_x0020_Fee" msprop:Generator_ColumnVarNameInTable="columnShipping_Fee" msprop:Generator_ColumnPropNameInRow="Shipping_Fee" msprop:Generator_ColumnPropNameInTable="Shipping_FeeColumn" msprop:Generator_UserColumnName="Shipping Fee" type="xs:decimal" minOccurs="0" />
              <xs:element name="Taxes" msprop:Generator_ColumnVarNameInTable="columnTaxes" msprop:Generator_ColumnPropNameInRow="Taxes" msprop:Generator_ColumnPropNameInTable="TaxesColumn" msprop:Generator_UserColumnName="Taxes" type="xs:decimal" minOccurs="0" />
              <xs:element name="Payment_x0020_Date" msprop:Generator_ColumnVarNameInTable="columnPayment_Date" msprop:Generator_ColumnPropNameInRow="Payment_Date" msprop:Generator_ColumnPropNameInTable="Payment_DateColumn" msprop:Generator_UserColumnName="Payment Date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Payment_x0020_Amount" msprop:Generator_ColumnVarNameInTable="columnPayment_Amount" msprop:Generator_ColumnPropNameInRow="Payment_Amount" msprop:Generator_ColumnPropNameInTable="Payment_AmountColumn" msprop:Generator_UserColumnName="Payment Amount" type="xs:decimal" minOccurs="0" />
              <xs:element name="Payment_x0020_Method" msprop:Generator_ColumnVarNameInTable="columnPayment_Method" msprop:Generator_ColumnPropNameInRow="Payment_Method" msprop:Generator_ColumnPropNameInTable="Payment_MethodColumn" msprop:Generator_UserColumnName="Payment Method" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnPropNameInTable="NotesColumn" msprop:Generator_UserColumnName="Notes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Approved_x0020_By" msprop:Generator_ColumnVarNameInTable="columnApproved_By" msprop:Generator_ColumnPropNameInRow="Approved_By" msprop:Generator_ColumnPropNameInTable="Approved_ByColumn" msprop:Generator_UserColumnName="Approved By" type="xs:int" minOccurs="0" />
              <xs:element name="Approved_x0020_Date" msprop:Generator_ColumnVarNameInTable="columnApproved_Date" msprop:Generator_ColumnPropNameInRow="Approved_Date" msprop:Generator_ColumnPropNameInTable="Approved_DateColumn" msprop:Generator_UserColumnName="Approved Date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Submitted_x0020_By" msprop:Generator_ColumnVarNameInTable="columnSubmitted_By" msprop:Generator_ColumnPropNameInRow="Submitted_By" msprop:Generator_ColumnPropNameInTable="Submitted_ByColumn" msprop:Generator_UserColumnName="Submitted By" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Suppliers" msprop:Generator_TableClassName="SuppliersDataTable" msprop:Generator_TableVarName="tableSuppliers" msprop:Generator_TablePropName="Suppliers" msprop:Generator_RowDeletingName="SuppliersRowDeleting" msprop:Generator_UserTableName="Suppliers" msprop:Generator_RowChangingName="SuppliersRowChanging" msprop:Generator_RowEvHandlerName="SuppliersRowChangeEventHandler" msprop:Generator_RowDeletedName="SuppliersRowDeleted" msprop:Generator_RowEvArgName="SuppliersRowChangeEvent" msprop:Generator_RowChangedName="SuppliersRowChanged" msprop:Generator_RowClassName="SuppliersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Company" msprop:Generator_ColumnVarNameInTable="columnCompany" msprop:Generator_ColumnPropNameInRow="Company" msprop:Generator_ColumnPropNameInTable="CompanyColumn" msprop:Generator_UserColumnName="Company" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Last_x0020_Name" msprop:Generator_ColumnVarNameInTable="columnLast_Name" msprop:Generator_ColumnPropNameInRow="Last_Name" msprop:Generator_ColumnPropNameInTable="Last_NameColumn" msprop:Generator_UserColumnName="Last Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="First_x0020_Name" msprop:Generator_ColumnVarNameInTable="columnFirst_Name" msprop:Generator_ColumnPropNameInRow="First_Name" msprop:Generator_ColumnPropNameInTable="First_NameColumn" msprop:Generator_UserColumnName="First Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E-mail_x0020_Address" msprop:Generator_ColumnVarNameInTable="_columnE_mail_Address" msprop:Generator_ColumnPropNameInRow="_E_mail_Address" msprop:Generator_ColumnPropNameInTable="_E_mail_AddressColumn" msprop:Generator_UserColumnName="E-mail Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Job_x0020_Title" msprop:Generator_ColumnVarNameInTable="columnJob_Title" msprop:Generator_ColumnPropNameInRow="Job_Title" msprop:Generator_ColumnPropNameInTable="Job_TitleColumn" msprop:Generator_UserColumnName="Job Title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Business_x0020_Phone" msprop:Generator_ColumnVarNameInTable="columnBusiness_Phone" msprop:Generator_ColumnPropNameInRow="Business_Phone" msprop:Generator_ColumnPropNameInTable="Business_PhoneColumn" msprop:Generator_UserColumnName="Business Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Home_x0020_Phone" msprop:Generator_ColumnVarNameInTable="columnHome_Phone" msprop:Generator_ColumnPropNameInRow="Home_Phone" msprop:Generator_ColumnPropNameInTable="Home_PhoneColumn" msprop:Generator_UserColumnName="Home Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Mobile_x0020_Phone" msprop:Generator_ColumnVarNameInTable="columnMobile_Phone" msprop:Generator_ColumnPropNameInRow="Mobile_Phone" msprop:Generator_ColumnPropNameInTable="Mobile_PhoneColumn" msprop:Generator_UserColumnName="Mobile Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fax_x0020_Number" msprop:Generator_ColumnVarNameInTable="columnFax_Number" msprop:Generator_ColumnPropNameInRow="Fax_Number" msprop:Generator_ColumnPropNameInTable="Fax_NumberColumn" msprop:Generator_UserColumnName="Fax Number" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State_x002F_Province" msprop:Generator_ColumnVarNameInTable="_columnState_Province" msprop:Generator_ColumnPropNameInRow="_State_Province" msprop:Generator_ColumnPropNameInTable="_State_ProvinceColumn" msprop:Generator_UserColumnName="State/Province" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ZIP_x002F_Postal_x0020_Code" msprop:Generator_ColumnVarNameInTable="_columnZIP_Postal_Code" msprop:Generator_ColumnPropNameInRow="_ZIP_Postal_Code" msprop:Generator_ColumnPropNameInTable="_ZIP_Postal_CodeColumn" msprop:Generator_UserColumnName="ZIP/Postal Code" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country_x002F_Region" msprop:Generator_ColumnVarNameInTable="_columnCountry_Region" msprop:Generator_ColumnPropNameInRow="_Country_Region" msprop:Generator_ColumnPropNameInTable="_Country_RegionColumn" msprop:Generator_UserColumnName="Country/Region" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Web_x0020_Page" msprop:Generator_ColumnVarNameInTable="columnWeb_Page" msprop:Generator_ColumnPropNameInRow="Web_Page" msprop:Generator_ColumnPropNameInTable="Web_PageColumn" msprop:Generator_UserColumnName="Web Page" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnPropNameInTable="NotesColumn" msprop:Generator_UserColumnName="Notes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Attachments" msprop:Generator_ColumnVarNameInTable="columnAttachments" msprop:Generator_ColumnPropNameInRow="Attachments" msprop:Generator_ColumnPropNameInTable="AttachmentsColumn" msprop:Generator_UserColumnName="Attachments" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Employees" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Products_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Products" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Purchase_x0020_Order_x0020_Details_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Purchase_x0020_Order_x0020_Details" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Purchase_x0020_Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Purchase_x0020_Orders" />
      <xs:field xpath="mstns:Purchase_x0020_Order_x0020_ID" />
    </xs:unique>
    <xs:unique name="Suppliers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Suppliers" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="New_ProductOnPurchaseOrderDetails" msdata:parent="Products" msdata:child="Purchase_x0020_Order_x0020_Details" msdata:parentkey="ID" msdata:childkey="Product_x0020_ID" msprop:Generator_UserChildTable="Purchase Order Details" msprop:Generator_ChildPropName="GetPurchase_Order_DetailsRows" msprop:Generator_UserParentTable="Products" msprop:Generator_UserRelationName="New_ProductOnPurchaseOrderDetails" msprop:Generator_RelationVarName="relationNew_ProductOnPurchaseOrderDetails" msprop:Generator_ParentPropName="ProductsRow" />
      <msdata:Relationship name="New_SuppliersOnPurchaseOrder" msdata:parent="Suppliers" msdata:child="Purchase_x0020_Orders" msdata:parentkey="ID" msdata:childkey="Supplier_x0020_ID" msprop:Generator_UserChildTable="Purchase Orders" msprop:Generator_ChildPropName="GetPurchase_OrdersRows" msprop:Generator_UserParentTable="Suppliers" msprop:Generator_UserRelationName="New_SuppliersOnPurchaseOrder" msprop:Generator_RelationVarName="relationNew_SuppliersOnPurchaseOrder" msprop:Generator_ParentPropName="SuppliersRow" />
      <msdata:Relationship name="New_PurchaseOrderDeatilsOnPurchaseOrder" msdata:parent="Purchase_x0020_Orders" msdata:child="Purchase_x0020_Order_x0020_Details" msdata:parentkey="Purchase_x0020_Order_x0020_ID" msdata:childkey="Purchase_x0020_Order_x0020_ID" msprop:Generator_UserChildTable="Purchase Order Details" msprop:Generator_ChildPropName="GetPurchase_Order_DetailsRows" msprop:Generator_UserParentTable="Purchase Orders" msprop:Generator_UserRelationName="New_PurchaseOrderDeatilsOnPurchaseOrder" msprop:Generator_RelationVarName="relationNew_PurchaseOrderDeatilsOnPurchaseOrder" msprop:Generator_ParentPropName="Purchase_OrdersRow" />
      <msdata:Relationship name="New_EmployeesOnPurchaseOrder" msdata:parent="Employees" msdata:child="Purchase_x0020_Orders" msdata:parentkey="ID" msdata:childkey="Created_x0020_By" msprop:Generator_UserChildTable="Purchase Orders" msprop:Generator_ChildPropName="GetPurchase_OrdersRows" msprop:Generator_UserParentTable="Employees" msprop:Generator_UserRelationName="New_EmployeesOnPurchaseOrder" msprop:Generator_RelationVarName="relationNew_EmployeesOnPurchaseOrder" msprop:Generator_ParentPropName="EmployeesRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>